﻿<html>
<head>
	<title>Projet EDD</title>
	<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
	<script type="text/javascript" src="./js/edd.js"></script>
	<link href="./css/style.css" rel="stylesheet" type="text/css" />
</head>
<body bgcolor="#FFFFFF" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<!-- ImageReady Slices (schema_fonctionnel.psd) -->
<center>
<table id="Table_01" width="934" height="474" border="0" cellpadding="0" cellspacing="0">
	<tr>
		<td colspan="21">
			<img src="images/schema_fonctionnel_01.jpg" width="933" height="50" alt=""></td>
		<td>
			<img src="images/spacer.gif" width="1" height="50" alt=""></td>
	</tr>
	<tr>
		<td colspan="2" rowspan="8">
			<img src="images/schema_fonctionnel_02.jpg" width="59" height="325" alt=""></td>
		<td colspan="3"><div id = 'region'>
			<img src="images/schema_fonctionnel_03.jpg" width="107" height="35" alt="Region"></div></td>
		<td colspan="16" rowspan="2">
			<img src="images/schema_fonctionnel_04.jpg" width="767" height="83" alt=""></td>
		<td>
			<img src="images/spacer.gif" width="1" height="35" alt=""></td>
	</tr>
	<tr>
		<td colspan="3" rowspan="2">
			<img src="images/schema_fonctionnel_05.jpg" width="107" height="71" alt=""></td>
		<td>
			<img src="images/spacer.gif" width="1" height="48" alt=""></td>
	</tr>
	<tr>
		<td colspan="7">
			<img src="images/schema_fonctionnel_06.jpg" width="370" height="23" alt=""></td>
		<td colspan="2" rowspan="2"><div id = 'category'>
			<img src="images/schema_fonctionnel_07.jpg" width="107" height="35" alt="Category"></div></td>
		<td colspan="4" rowspan="4">
			<img src="images/schema_fonctionnel_08.jpg" width="157" height="114" alt=""></td>
		<td colspan="2" rowspan="2"><div id = 'supplier'>
			<img src="images/schema_fonctionnel_09.jpg" width="107" height="35" alt="Supplier"></div></td>
		<td rowspan="11">
			<img src="images/schema_fonctionnel_10.jpg" width="26" height="340" alt=""></td>
		<td>
			<img src="images/spacer.gif" width="1" height="23" alt=""></td>
	</tr>
	<tr>
		<td colspan="2" rowspan="5">
			<img src="images/schema_fonctionnel_11.jpg" width="90" height="219" alt=""></td>
		<td colspan="3" rowspan="2"><div id = 'city'>
			<img src="images/schema_fonctionnel_12.jpg" width="109" height="35" alt="City"></div></td>
		<td colspan="5" rowspan="3">
			<img src="images/schema_fonctionnel_13.jpg" width="278" height="91" alt=""></td>
		<td>
			<img src="images/spacer.gif" width="1" height="12" alt=""></td>
	</tr>
	<tr>
		<td colspan="2" rowspan="5">
			<img src="images/schema_fonctionnel_14.jpg" width="107" height="208" alt=""></td>
		<td colspan="2" rowspan="5">
			<img src="images/schema_fonctionnel_15.jpg" width="107" height="208" alt=""></td>
		<td>
			<img src="images/spacer.gif" width="1" height="23" alt=""></td>
	</tr>
	<tr>
		<td colspan="3" rowspan="4">
			<img src="images/schema_fonctionnel_16.jpg" width="109" height="185" alt=""></td>
		<td>
			<img src="images/spacer.gif" width="1" height="56" alt=""></td>
	</tr>
	<tr>
		<td rowspan="3">
			<img src="images/schema_fonctionnel_17.jpg" width="21" height="129" alt=""></td>
		<td colspan="2"><div id = 'store'>
			<img src="images/schema_fonctionnel_18.jpg" width="107" height="35" alt="Store"></div></td>
		<td colspan="2" rowspan="3">
			<img src="images/schema_fonctionnel_19.jpg" width="150" height="129" alt=""></td>
		<td rowspan="7">
			<img src="images/schema_fonctionnel_20.jpg" width="14" height="226" alt=""></td>
		<td colspan="2"><div id = 'product'>
			<img src="images/schema_fonctionnel_21.jpg" width="107" height="35" alt="Product"></div></td>
		<td rowspan="3">
			<img src="images/schema_fonctionnel_22.jpg" width="36" height="129" alt=""></td>
		<td>
			<img src="images/spacer.gif" width="1" height="35" alt=""></td>
	</tr>
	<tr>
		<td colspan="2" rowspan="2">
			<img src="images/schema_fonctionnel_23.jpg" width="107" height="94" alt=""></td>
		<td colspan="2" rowspan="2">
			<img src="images/schema_fonctionnel_24.jpg" width="107" height="94" alt=""></td>
		<td>
			<img src="images/spacer.gif" width="1" height="93" alt=""></td>
	</tr>
	<tr>
		<td rowspan="5">
			<img src="images/schema_fonctionnel_25.jpg" width="29" height="98" alt=""></td>
		<td colspan="2" rowspan="3"><div id = 'month'>
			<img src="images/schema_fonctionnel_26.jpg" width="107" height="35" alt="Month"></div></td>
		<td rowspan="5">
			<img src="images/schema_fonctionnel_27.jpg" width="13" height="98" alt=""></td>
		<td>
			<img src="images/spacer.gif" width="1" height="1" alt=""></td>
	</tr>
	<tr>
		<td colspan="2" rowspan="4">
			<img src="images/schema_fonctionnel_28.jpg" width="84" height="97" alt=""></td>
		<td colspan="3"><div id = 'date'>
			<img src="images/schema_fonctionnel_28-30.jpg" width="107" height="35" alt="Date"></div></td>
		<td colspan="2" rowspan="4">
			<img src="images/schema_fonctionnel_30.jpg" width="105" height="97" alt=""></td>
		<td colspan="2" rowspan="3"><div id = 'o'>
			<img src="images/schema_fonctionnel_30-32.jpg" width="107" height="35" alt="O"></div></td>
		<td rowspan="4">
			<img src="images/schema_fonctionnel_32.jpg" width="91" height="97" alt=""></td>
		<td rowspan="4">
			<img src="images/schema_fonctionnel_33.jpg" width="53" height="97" alt=""></td>
		<td colspan="3" rowspan="3"><div id = 'quantity'>
			<img src="images/schema_fonctionnel_33-35.jpg" width="107" height="35" alt="Quatity"></div></td>
		<td rowspan="4">
			<img src="images/schema_fonctionnel_35.jpg" width="90" height="97" alt=""></td>
		<td>
			<img src="images/spacer.gif" width="1" height="33" alt=""></td>
	</tr>
	<tr>
		<td colspan="3" rowspan="3">
			<img src="images/schema_fonctionnel_36.jpg" width="107" height="64" alt=""></td>
		<td>
			<img src="images/spacer.gif" width="1" height="1" alt=""></td>
	</tr>
	<tr>
		<td colspan="2" rowspan="2">
			<img src="images/schema_fonctionnel_37.jpg" width="107" height="63" alt=""></td>
		<td>
			<img src="images/spacer.gif" width="1" height="1" alt=""></td>
	</tr>
	<tr>
		<td colspan="2">
			<img src="images/schema_fonctionnel_38.jpg" width="107" height="62" alt=""></td>
		<td colspan="3">
			<img src="images/schema_fonctionnel_39.jpg" width="107" height="62" alt=""></td>
		<td>
			<img src="images/spacer.gif" width="1" height="62" alt=""></td>
	</tr>
	<tr>
		<td>
			<img src="images/spacer.gif" width="29" height="1" alt=""></td>
		<td>
			<img src="images/spacer.gif" width="30" height="1" alt=""></td>
		<td>
			<img src="images/spacer.gif" width="77" height="1" alt=""></td>
		<td>
			<img src="images/spacer.gif" width="13" height="1" alt=""></td>
		<td>
			<img src="images/spacer.gif" width="17" height="1" alt=""></td>
		<td>
			<img src="images/spacer.gif" width="67" height="1" alt=""></td>
		<td>
			<img src="images/spacer.gif" width="25" height="1" alt=""></td>
		<td>
			<img src="images/spacer.gif" width="21" height="1" alt=""></td>
		<td>
			<img src="images/spacer.gif" width="61" height="1" alt=""></td>
		<td>
			<img src="images/spacer.gif" width="46" height="1" alt=""></td>
		<td>
			<img src="images/spacer.gif" width="59" height="1" alt=""></td>
		<td>
			<img src="images/spacer.gif" width="91" height="1" alt=""></td>
		<td>
			<img src="images/spacer.gif" width="16" height="1" alt=""></td>
		<td>
			<img src="images/spacer.gif" width="91" height="1" alt=""></td>
		<td>
			<img src="images/spacer.gif" width="14" height="1" alt=""></td>
		<td>
			<img src="images/spacer.gif" width="53" height="1" alt=""></td>
		<td>
			<img src="images/spacer.gif" width="54" height="1" alt=""></td>
		<td>
			<img src="images/spacer.gif" width="36" height="1" alt=""></td>
		<td>
			<img src="images/spacer.gif" width="17" height="1" alt=""></td>
		<td>
			<img src="images/spacer.gif" width="90" height="1" alt=""></td>
		<td>
			<img src="images/spacer.gif" width="26" height="1" alt=""></td>
		<td></td>
	</tr>
</table>
<a href='./refreshDB.php'>Click here to refresh the data warehouse</a>
</center>

<div id = 'container'>
<div class="note">
	<ul>
		<li>Click on the classificateur or mesure to choose your elements. Then choose an operateur. Finally press <strong>Submit</strong> to send your query</li>
		<li>You can also add restriction to any element of the classificateur, values separated by '<strong>;</strong>' (ig: Paris;Nice;Lyon;...).</li>
		<li>The output variable name can be defined as you want</li>
	</ul>
</div>

<form method="post" action="./query.php">
	<fieldset>
   	<legend><input id = 'C' type = 'radio' name = 'isClassificateur' /><label for='C'><strong>Classificateur !</strong></label></legend>
		<span id="classificateur"></span>
	</fieldset><br />
	<fieldset>
   	<legend><input id = 'M' type = 'radio' name = 'isClassificateur' /><label for='M'><strong>Mesure !</strong></label></legend>
		<span id="mesure"></span>
	</fieldset>
	<br />
	<input type="submit" value="Submit" name="valider" id="valider" />
</form>
</div>
</body>
</html>